Citi Bike Data Profiling Report

Dataset statistics

Number of variables	17
Number of observations	4154739
Missing cells	13024555
Missing cells (%)	18.4%
Duplicate rows	13752
Duplicate rows (%)	0.3%
Total size in memory	2.0 GiB
Average record size in memory	517.0 B

Variable types

Numeric	7
DateTime	2
Unsupported	2
Text	3
Categorical	3

Alerts

Dataset has 13752 (0.3%) duplicate rows	Duplicates
`start_time` has 1092248 (26.3%) missing values	Missing
`stop_time` has 1092248 (26.3%) missing values	Missing
`bike_id` has 2483972 (59.8%) missing values	Missing
`birth_year` has 2524704 (60.8%) missing values	Missing
`gender` has 2483972 (59.8%) missing values	Missing
`ride_id` has 1670767 (40.2%) missing values	Missing
`rideable_type` has 1670767 (40.2%) missing values	Missing
`start_station_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`end_station_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-01-21 20:14:47.599019
Analysis finished	2024-01-21 20:18:15.390988
Duration	3 minutes and 27.79 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

trip_duration
Real number (ℝ)

Distinct	5271
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	625.74895

Minimum	1
Maximum	5271
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	1
5-th percentile	127
Q1	254
median	404
Q3	693
95-th percentile	2005
Maximum	5271
Range	5270
Interquartile range (IQR)	439

Descriptive statistics

Standard deviation	678.04054
Coefficient of variation (CV)	1.0835664
Kurtosis	11.592739
Mean	625.74895
Median Absolute Deviation (MAD)	183
Skewness	3.0543369
Sum	2.5998236 × 10⁹
Variance	459738.98
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
248	8236	0.2%
252	8224	0.2%
256	8205	0.2%
244	8200	0.2%
253	8177	0.2%
241	8173	0.2%
246	8168	0.2%
251	8155	0.2%
249	8155	0.2%
243	8152	0.2%
Other values (5261)	4072894	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	889	< 0.1%
2	1840	< 0.1%
3	1558	< 0.1%
4	1149	< 0.1%
5	1050	< 0.1%
6	964	< 0.1%
7	1015	< 0.1%
8	950	< 0.1%
9	891	< 0.1%
10	860	< 0.1%

Value	Count	Frequency (%)
5271	19	< 0.1%
5270	16	< 0.1%
5269	13	< 0.1%
5268	13	< 0.1%
5267	9	< 0.1%
5266	17	< 0.1%
5265	17	< 0.1%
5264	12	< 0.1%
5263	18	< 0.1%
5262	11	< 0.1%

start_time
Date

MISSING

Distinct	2987105
Distinct (%)	97.5%
Missing	1092248
Missing (%)	26.3%
Memory size	63.4 MiB

Minimum	2015-09-21 14:53:16
Maximum	2023-12-31 23:59:57

Histogram

Histogram with fixed size bins (bins=50)

stop_time
Date

MISSING

Distinct	2989726
Distinct (%)	97.6%
Missing	1092248
Missing (%)	26.3%
Memory size	63.4 MiB

Minimum	2015-09-21 14:54:17
Maximum	2024-01-01 00:28:15

Histogram

Histogram with fixed size bins (bins=50)

start_station_id
Unsupported

REJECTED UNSUPPORTED

Missing	87
Missing (%)	< 0.1%
Memory size	254.6 MiB

start_station_name
Text

Distinct	319
Distinct (%)	< 0.1%
Missing	87
Missing (%)	< 0.1%
Memory size	324.4 MiB

Length

Max length	44
Median length	38
Mean length	16.871595
Min length	4

Characters and Unicode

Total characters	70095604
Distinct characters	63
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	172 ?
Unique (%)	< 0.1%

Sample

1st row	Marin Light Rail
2nd row	Exchange Place
3rd row	Exchange Place
4th row	McGinley Square
5th row	Exchange Place

Value	Count	Frequency (%)
st	2463073	16.7%
	1854592	12.6%
ave	491720	3.3%
park	477837	3.2%
path	430822	2.9%
grove	296914	2.0%
hudson	283686	1.9%
newport	256467	1.7%
rail	241798	1.6%
light	241798	1.6%
Other values (313)	7674110	52.2%

Most occurring characters

Value	Count	Frequency (%)
	10558167	15.1%
t	5061636	7.2%
r	4169273	5.9%
a	4148751	5.9%
e	3767796	5.4%
o	3566946	5.1%
n	3556869	5.1%
S	3066563	4.4%
i	3035366	4.3%
l	2436196	3.5%
Other values (53)	26728041	38.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43206494	61.6%
Uppercase Letter	12987092	18.5%
Space Separator	10558167	15.1%
Decimal Number	1489253	2.1%
Other Punctuation	1330824	1.9%
Dash Punctuation	523772	0.7%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	5061636	11.7%
r	4169273	9.6%
a	4148751	9.6%
e	3767796	8.7%
o	3566946	8.3%
n	3556869	8.2%
i	3035366	7.0%
l	2436196	5.6%
s	1849751	4.3%
k	1355919	3.1%
Other values (15)	10257991	23.7%

Uppercase Letter

Value	Count	Frequency (%)
S	3066563	23.6%
H	1542175	11.9%
P	1471505	11.3%
A	985173	7.6%
M	712580	5.5%
C	689331	5.3%
T	626203	4.8%
G	531651	4.1%
L	521317	4.0%
W	503835	3.9%
Other values (13)	2336759	18.0%

Decimal Number

Value	Count	Frequency (%)
1	607167	40.8%
4	198586	13.3%
6	196254	13.2%
2	127049	8.5%
5	82241	5.5%
8	72028	4.8%
9	64147	4.3%
7	60661	4.1%
3	57331	3.8%
0	23789	1.6%

Space Separator

Value	Count	Frequency (%)
	10558167	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	1330824	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	523772	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56193586	80.2%
Common	13902018	19.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	5061636	9.0%
r	4169273	7.4%
a	4148751	7.4%
e	3767796	6.7%
o	3566946	6.3%
n	3556869	6.3%
S	3066563	5.5%
i	3035366	5.4%
l	2436196	4.3%
s	1849751	3.3%
Other values (38)	21534439	38.3%

Common

Value	Count	Frequency (%)
	10558167	75.9%
&	1330824	9.6%
1	607167	4.4%
-	523772	3.8%
4	198586	1.4%
6	196254	1.4%
2	127049	0.9%
5	82241	0.6%
8	72028	0.5%
9	64147	0.5%
Other values (5)	141783	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70095604	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	10558167	15.1%
t	5061636	7.2%
r	4169273	5.9%
a	4148751	5.9%
e	3767796	5.4%
o	3566946	5.1%
n	3556869	5.1%
S	3066563	4.4%
i	3035366	4.3%
l	2436196	3.5%
Other values (53)	26728041	38.1%

start_station_latitude
Real number (ℝ)

Distinct	128281
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728069

Minimum	40.678334
Maximum	40.806619
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	40.678334
5-th percentile	40.712774
Q1	40.719252
median	40.725685
Q3	40.736982
95-th percentile	40.749985
Maximum	40.806619
Range	0.12828463
Interquartile range (IQR)	0.017730518

Descriptive statistics

Standard deviation	0.01141219
Coefficient of variation (CV)	0.00028020455
Kurtosis	-0.65359517
Mean	40.728069
Median Absolute Deviation (MAD)	0.0079534836
Skewness	0.5754121
Sum	1.692145 × 10⁸
Variance	0.00013023809
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71958612	238391	5.7%
40.72759597	142834	3.4%
40.7272235	119577	2.9%
40.7287448	109393	2.6%
40.71458404	90710	2.2%
40.7192517	79290	1.9%
40.7177325	78799	1.9%
40.7211236	77973	1.9%
40.7112423	74476	1.8%
40.72152515	73676	1.8%
Other values (128271)	3069620	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.67833407	1	< 0.1%
40.69187865	1	< 0.1%
40.69263997	304	< 0.1%
40.69531906	1	< 0.1%
40.6970299	507	< 0.1%
40.69865054	607	< 0.1%
40.69967915	1	< 0.1%
40.70068073	1	< 0.1%
40.70362493	1	< 0.1%
40.70452571	1	< 0.1%

Value	Count	Frequency (%)
40.8066187	1	< 0.1%
40.8028376	1	< 0.1%
40.79953315	1	< 0.1%
40.79118803	1	< 0.1%
40.78903018	9	< 0.1%
40.78179272	1	< 0.1%
40.78096507	1	< 0.1%
40.77986812	2	< 0.1%
40.77917727	1	< 0.1%
40.77564173	1	< 0.1%

start_station_longitude
Real number (ℝ)

Distinct	136378
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-74.042824

Minimum	-74.096937
Maximum	-73.997279
Zeros	0
Zeros (%)	0.0%
Negative	4154739
Negative (%)	100.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	-74.096937
5-th percentile	-74.067104
Q1	-74.04879
median	-74.042817
Q3	-74.033552
95-th percentile	-74.027781
Maximum	-73.997279
Range	0.099658033
Interquartile range (IQR)	0.015238436

Descriptive statistics

Standard deviation	0.012030775
Coefficient of variation (CV)	-0.00016248402
Kurtosis	0.52153601
Mean	-74.042824
Median Absolute Deviation (MAD)	0.0081729438
Skewness	-0.92486155
Sum	-3.0762861 × 10⁸
Variance	0.00014473956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-74.04311746	238391	5.7%
-74.04424731	142834	3.4%
-74.0337589	119577	2.9%
-74.0321082	109393	2.6%
-74.04281706	90710	2.2%
-74.034234	83288	2.0%
-74.043845	82173	2.0%
-74.03805095	77973	1.9%
-74.0557013	74476	1.8%
-74.04630454	73676	1.8%
Other values (136368)	3062248	73.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.0969366	507	< 0.1%
-74.08896387	2	< 0.1%
-74.0887723	689	< 0.1%
-74.08801228	304	< 0.1%
-74.08722293	1	< 0.1%
-74.08706903	1	< 0.1%
-74.0868541	1	< 0.1%
-74.08684921	1	< 0.1%
-74.08684228	1	< 0.1%
-74.08682585	1	< 0.1%

Value	Count	Frequency (%)
-73.99727857	1	< 0.1%
-73.99793313	9	< 0.1%
-73.99886102	1	< 0.1%
-74.00098978	2	< 0.1%
-74.00336778	1	< 0.1%
-74.00455577	1	< 0.1%
-74.00700725	1	< 0.1%
-74.00907335	1	< 0.1%
-74.01260012	4	< 0.1%
-74.0140628	1	< 0.1%

end_station_id
Unsupported

REJECTED UNSUPPORTED

Missing	2608
Missing (%)	0.1%
Memory size	254.6 MiB

end_station_name
Text

Distinct	586
Distinct (%)	< 0.1%
Missing	2608
Missing (%)	0.1%
Memory size	324.5 MiB

Length

Max length	55
Median length	40
Mean length	16.924165
Min length	4

Characters and Unicode

Total characters	70271349
Distinct characters	66
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	165 ?
Unique (%)	< 0.1%

Sample

1st row	City Hall
2nd row	Heights Elevator
3rd row	Newark Ave
4th row	Danforth Light Rail
5th row	Hamilton Park

Value	Count	Frequency (%)
st	2524756	17.1%
	1855311	12.5%
path	487486	3.3%
park	469073	3.2%
ave	467573	3.2%
grove	350723	2.4%
hudson	284030	1.9%
newport	259493	1.8%
pl	246014	1.7%
rail	245556	1.7%
Other values (415)	7611810	51.4%

Most occurring characters

Value	Count	Frequency (%)
	10649710	15.2%
t	5101326	7.3%
r	4143604	5.9%
a	4123322	5.9%
e	3775432	5.4%
o	3587533	5.1%
n	3522114	5.0%
S	3109347	4.4%
i	2976355	4.2%
l	2408860	3.4%
Other values (56)	26873746	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43033503	61.2%
Uppercase Letter	13245182	18.8%
Space Separator	10649710	15.2%
Decimal Number	1486988	2.1%
Other Punctuation	1328776	1.9%
Dash Punctuation	527163	0.8%
Close Punctuation	13	< 0.1%
Open Punctuation	13	< 0.1%
Connector Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	5101326	11.9%
r	4143604	9.6%
a	4123322	9.6%
e	3775432	8.8%
o	3587533	8.3%
n	3522114	8.2%
i	2976355	6.9%
l	2408860	5.6%
s	1817937	4.2%
k	1336023	3.1%
Other values (15)	10240997	23.8%

Uppercase Letter

Value	Count	Frequency (%)
S	3109347	23.5%
H	1588366	12.0%
P	1537133	11.6%
A	1018401	7.7%
M	691193	5.2%
C	687070	5.2%
T	682458	5.2%
G	567973	4.3%
L	529544	4.0%
W	509125	3.8%
Other values (13)	2324572	17.6%

Decimal Number

Value	Count	Frequency (%)
1	617125	41.5%
4	201283	13.5%
6	182305	12.3%
2	128816	8.7%
5	79211	5.3%
8	71700	4.8%
9	64998	4.4%
7	61398	4.1%
3	54841	3.7%
0	25311	1.7%

Other Punctuation

Value	Count	Frequency (%)
&	1328166	> 99.9%
'	596	< 0.1%
\	14	< 0.1%

Space Separator

Value	Count	Frequency (%)
	10649710	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	527163	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	13	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	13	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56278685	80.1%
Common	13992664	19.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	5101326	9.1%
r	4143604	7.4%
a	4123322	7.3%
e	3775432	6.7%
o	3587533	6.4%
n	3522114	6.3%
S	3109347	5.5%
i	2976355	5.3%
l	2408860	4.3%
s	1817937	3.2%
Other values (38)	21712855	38.6%

Common

Value	Count	Frequency (%)
	10649710	76.1%
&	1328166	9.5%
1	617125	4.4%
-	527163	3.8%
4	201283	1.4%
6	182305	1.3%
2	128816	0.9%
5	79211	0.6%
8	71700	0.5%
9	64998	0.5%
Other values (8)	142187	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70271349	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	10649710	15.2%
t	5101326	7.3%
r	4143604	5.9%
a	4123322	5.9%
e	3775432	5.4%
o	3587533	5.1%
n	3522114	5.0%
S	3109347	4.4%
i	2976355	4.2%
l	2408860	3.4%
Other values (56)	26873746	38.2%

end_station_latitude
Real number (ℝ)

Distinct	683
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.72787

Minimum	40.64507
Maximum	40.832164
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	40.64507
5-th percentile	40.712774
Q1	40.719252
median	40.72534
Q3	40.736068
95-th percentile	40.749985
Maximum	40.832164
Range	0.187094
Interquartile range (IQR)	0.016815956

Descriptive statistics

Standard deviation	0.011485306
Coefficient of variation (CV)	0.00028200114
Kurtosis	-0.60761009
Mean	40.72787
Median Absolute Deviation (MAD)	0.0076074254
Skewness	0.61049202
Sum	1.6921367 × 10⁸
Variance	0.00013191224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71958612	297863	7.2%
40.72759597	152564	3.7%
40.7272235	136301	3.3%
40.7287448	122024	2.9%
40.71458404	99974	2.4%
40.73606766	91852	2.2%
40.7177325	91630	2.2%
40.73698222	90033	2.2%
40.7192517	88715	2.1%
40.7112423	87852	2.1%
Other values (673)	2895931	69.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.64507	1	< 0.1%
40.646377	1	< 0.1%
40.649292	1	< 0.1%
40.64958	1	< 0.1%
40.6630619	1	< 0.1%
40.6663181	1	< 0.1%
40.6679411	1	< 0.1%
40.66967	1	< 0.1%
40.67	1	< 0.1%
40.6704922	2	< 0.1%

Value	Count	Frequency (%)
40.832164	1	< 0.1%
40.8120562	1	< 0.1%
40.8082	4	< 0.1%
40.8078316	1	< 0.1%
40.8067581	4	< 0.1%
40.805973	1	< 0.1%
40.804213	3	< 0.1%
40.802692	1	< 0.1%
40.801694	1	< 0.1%
40.8008363	1	< 0.1%

end_station_longitude
Real number (ℝ)

Distinct	682
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-74.042467

Minimum	-74.11
Maximum	-73.948603
Zeros	0
Zeros (%)	0.0%
Negative	4154739
Negative (%)	100.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	-74.11
5-th percentile	-74.066611
Q1	-74.047727
median	-74.042817
Q3	-74.033552
95-th percentile	-74.027781
Maximum	-73.948603
Range	0.16139706
Interquartile range (IQR)	0.014174725

Descriptive statistics

Standard deviation	0.011955561
Coefficient of variation (CV)	-0.00016146897
Kurtosis	0.96656422
Mean	-74.042467
Median Absolute Deviation (MAD)	0.0078393438
Skewness	-0.9367918
Sum	-3.0762713 × 10⁸
Variance	0.00014293543
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-74.04311746	297863	7.2%
-74.04424731	152564	3.7%
-74.0337589	136301	3.3%
-74.0321082	122024	2.9%
-74.04281706	99974	2.4%
-74.043845	92074	2.2%
-74.02912706	91852	2.2%
-74.02778059	90033	2.2%
-74.034234	89193	2.1%
-74.0557013	87852	2.1%
Other values (672)	2895009	69.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.11	3	< 0.1%
-74.1	9	< 0.1%
-74.0969366	553	< 0.1%
-74.09	11	< 0.1%
-74.08896387	2	< 0.1%
-74.0887723	993	< 0.1%
-74.08801228	355	< 0.1%
-74.086701	23	< 0.1%
-74.08670068	3125	0.1%
-74.08593088	108	< 0.1%

Value	Count	Frequency (%)
-73.94860294	1	< 0.1%
-73.9488	1	< 0.1%
-73.9488134	1	< 0.1%
-73.949373	1	< 0.1%
-73.94963041	1	< 0.1%
-73.949702	1	< 0.1%
-73.9503	2	< 0.1%
-73.950503	2	< 0.1%
-73.95068615	1	< 0.1%
-73.95095259	3	< 0.1%

bike_id
Real number (ℝ)

MISSING

Distinct	3110
Distinct (%)	0.2%
Missing	2483972
Missing (%)	59.8%
Infinite	0
Infinite (%)	0.0%
Mean	30498.736

Minimum	14529
Maximum	49985
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	14529
5-th percentile	24475
Q1	26219
median	29299
Q3	31695
95-th percentile	44212
Maximum	49985
Range	35456
Interquartile range (IQR)	5476

Descriptive statistics

Standard deviation	6240.8602
Coefficient of variation (CV)	0.20462684
Kurtosis	0.39520877
Mean	30498.736
Median Absolute Deviation (MAD)	3049
Skewness	1.1924102
Sum	5.0956282 × 10¹⁰
Variance	38948336
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26159	2688	0.1%
26260	2677	0.1%
26161	2659	0.1%
26236	2658	0.1%
26170	2653	0.1%
26306	2647	0.1%
26431	2629	0.1%
26192	2620	0.1%
26213	2617	0.1%
26286	2605	0.1%
Other values (3100)	1644314	39.6%
(Missing)	2483972	59.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14529	3	< 0.1%
14531	43	< 0.1%
14536	19	< 0.1%
14552	10	< 0.1%
14556	34	< 0.1%
14578	3	< 0.1%
14585	100	< 0.1%
14598	57	< 0.1%
14607	175	< 0.1%
14632	1	< 0.1%

Value	Count	Frequency (%)
49985	5	< 0.1%
49734	3	< 0.1%
49527	14	< 0.1%
49081	19	< 0.1%
49058	5	< 0.1%
48932	94	< 0.1%
48930	63	< 0.1%
48929	60	< 0.1%
48924	92	< 0.1%
48923	66	< 0.1%

user_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	487
Missing (%)	< 0.1%
Memory size	261.5 MiB

1	3162902
0	991350

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4154252
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	3162902	76.1%
0	991350	23.9%
(Missing)	487	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	3162902	76.1%
0	991350	23.9%

Most occurring characters

Value	Count	Frequency (%)
1	3162902	76.1%
0	991350	23.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4154252	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	3162902	76.1%
0	991350	23.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	4154252	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	3162902	76.1%
0	991350	23.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4154252	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	3162902	76.1%
0	991350	23.9%

birth_year
Real number (ℝ)

MISSING

Distinct	81
Distinct (%)	< 0.1%
Missing	2524704
Missing (%)	60.8%
Infinite	0
Infinite (%)	0.0%
Mean	1980.5907

Minimum	1887
Maximum	2004
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	63.4 MiB

Quantile statistics

Minimum	1887
5-th percentile	1960
Q1	1974
median	1983
Q3	1988
95-th percentile	1994
Maximum	2004
Range	117
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	10.336333
Coefficient of variation (CV)	0.0052188135
Kurtosis	1.4461822
Mean	1980.5907
Median Absolute Deviation (MAD)	6
Skewness	-0.89322602
Sum	3.2284321 × 10⁹
Variance	106.83979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1969	103535	2.5%
1989	83871	2.0%
1986	82971	2.0%
1988	81748	2.0%
1987	75175	1.8%
1984	72459	1.7%
1990	71014	1.7%
1983	66513	1.6%
1985	64494	1.6%
1981	62911	1.5%
Other values (71)	865344	20.8%
(Missing)	2524704	60.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1887	70	< 0.1%
1888	260	< 0.1%
1889	4	< 0.1%
1900	65	< 0.1%
1901	1	< 0.1%
1904	19	< 0.1%
1918	2	< 0.1%
1920	1	< 0.1%
1923	3	< 0.1%
1930	4	< 0.1%

Value	Count	Frequency (%)
2004	23	< 0.1%
2003	276	< 0.1%
2002	622	< 0.1%
2001	1405	< 0.1%
2000	2649	0.1%
1999	2737	0.1%
1998	5699	0.1%
1997	7657	0.2%
1996	16328	0.4%
1995	20409	0.5%

gender
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	2483972
Missing (%)	59.8%
Memory size	260.0 MiB

1.0	1162335
2.0	371323
0.0	137109

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	5012301
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	1162335	28.0%
2.0	371323	8.9%
0.0	137109	3.3%
(Missing)	2483972	59.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	1162335	69.6%
2.0	371323	22.2%
0.0	137109	8.2%

Most occurring characters

Value	Count	Frequency (%)
0	1807876	36.1%
.	1670767	33.3%
1	1162335	23.2%
2	371323	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3341534	66.7%
Other Punctuation	1670767	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1807876	54.1%
1	1162335	34.8%
2	371323	11.1%

Other Punctuation

Value	Count	Frequency (%)
.	1670767	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5012301	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1807876	36.1%
.	1670767	33.3%
1	1162335	23.2%
2	371323	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5012301	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1807876	36.1%
.	1670767	33.3%
1	1162335	23.2%
2	371323	7.4%

ride_id
Text

MISSING

Distinct	2483972
Distinct (%)	100.0%
Missing	1670767
Missing (%)	40.2%
Memory size	255.6 MiB

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	39743552
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2483972 ?
Unique (%)	100.0%

Sample

1st row	58EEE2950FFE01CE
2nd row	1429D912C16EEE59
3rd row	FE9C5B74167CBCCD
4th row	B88D37626F000BBA
5th row	2A75E47239553321

Value	Count	Frequency (%)
58eee2950ffe01ce	1	< 0.1%
fe9c5b74167cbccd	1	< 0.1%
b88d37626f000bba	1	< 0.1%
9055e11e8d414319	1	< 0.1%
2a99fcafc6b1c7ce	1	< 0.1%
b31e3625915a88e1	1	< 0.1%
e0b99a4aaca77034	1	< 0.1%
bd52c7872af620e6	1	< 0.1%
20bd42adad2ca6a0	1	< 0.1%
23467b6f12bca65b	1	< 0.1%
Other values (2483962)	2483962	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
3	2485763	6.3%
8	2485669	6.3%
2	2485302	6.3%
5	2485292	6.3%
A	2485246	6.3%
D	2484400	6.3%
1	2484339	6.3%
F	2484106	6.3%
E	2483925	6.2%
7	2483842	6.2%
Other values (6)	14895668	37.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24839670	62.5%
Uppercase Letter	14903882	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	2485763	10.0%
8	2485669	10.0%
2	2485302	10.0%
5	2485292	10.0%
1	2484339	10.0%
7	2483842	10.0%
9	2482906	10.0%
4	2482782	10.0%
0	2481904	10.0%
6	2481871	10.0%

Uppercase Letter

Value	Count	Frequency (%)
A	2485246	16.7%
D	2484400	16.7%
F	2484106	16.7%
E	2483925	16.7%
B	2483794	16.7%
C	2482411	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	24839670	62.5%
Latin	14903882	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	2485763	10.0%
8	2485669	10.0%
2	2485302	10.0%
5	2485292	10.0%
1	2484339	10.0%
7	2483842	10.0%
9	2482906	10.0%
4	2482782	10.0%
0	2481904	10.0%
6	2481871	10.0%

Latin

Value	Count	Frequency (%)
A	2485246	16.7%
D	2484400	16.7%
F	2484106	16.7%
E	2483925	16.7%
B	2483794	16.7%
C	2482411	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39743552	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	2485763	6.3%
8	2485669	6.3%
2	2485302	6.3%
5	2485292	6.3%
A	2485246	6.3%
D	2484400	6.3%
1	2484339	6.3%
F	2484106	6.3%
E	2483925	6.2%
7	2483842	6.2%
Other values (6)	14895668	37.5%

rideable_type
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	1670767
Missing (%)	40.2%
Memory size	284.7 MiB

classic_bike	1826721
electric_bike	520799
docked_bike	136452

Length

Max length	13
Median length	12
Mean length	12.154731
Min length	11

Characters and Unicode

Total characters	30192011
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	docked_bike
2nd row	docked_bike
3rd row	docked_bike
4th row	docked_bike
5th row	docked_bike

Common Values

Value	Count	Frequency (%)
classic_bike	1826721	44.0%
electric_bike	520799	12.5%
docked_bike	136452	3.3%
(Missing)	1670767	40.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
classic_bike	1826721	73.5%
electric_bike	520799	21.0%
docked_bike	136452	5.5%

Most occurring characters

Value	Count	Frequency (%)
c	4831492	16.0%
i	4831492	16.0%
e	3662022	12.1%
s	3653442	12.1%
k	2620424	8.7%
b	2483972	8.2%
_	2483972	8.2%
l	2347520	7.8%
a	1826721	6.1%
t	520799	1.7%
Other values (3)	930155	3.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	27708039	91.8%
Connector Punctuation	2483972	8.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	4831492	17.4%
i	4831492	17.4%
e	3662022	13.2%
s	3653442	13.2%
k	2620424	9.5%
b	2483972	9.0%
l	2347520	8.5%
a	1826721	6.6%
t	520799	1.9%
r	520799	1.9%
Other values (2)	409356	1.5%

Connector Punctuation

Value	Count	Frequency (%)
_	2483972	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27708039	91.8%
Common	2483972	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	4831492	17.4%
i	4831492	17.4%
e	3662022	13.2%
s	3653442	13.2%
k	2620424	9.5%
b	2483972	9.0%
l	2347520	8.5%
a	1826721	6.6%
t	520799	1.9%
r	520799	1.9%
Other values (2)	409356	1.5%

Common

Value	Count	Frequency (%)
_	2483972	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30192011	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	4831492	16.0%
i	4831492	16.0%
e	3662022	12.1%
s	3653442	12.1%
k	2620424	8.7%
b	2483972	8.2%
_	2483972	8.2%
l	2347520	7.8%
a	1826721	6.1%
t	520799	1.7%
Other values (3)	930155	3.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	trip_duration	start_time	stop_time	start_station_id	start_station_name	start_station_latitude	start_station_longitude	end_station_id	end_station_name	end_station_latitude	end_station_longitude	bike_id	user_type	birth_year	gender	ride_id	rideable_type
0	148.0	2017-01-01 00:21:32	2017-01-01 00:24:01	3276	Marin Light Rail	40.714584	-74.042817	3185	City Hall	40.717732	-74.043845	24575.0	1	1983.0	1.0	NaN	NaN
1	1283.0	2017-01-01 00:24:35	2017-01-01 00:45:58	3183	Exchange Place	40.716247	-74.033459	3198	Heights Elevator	40.748716	-74.040443	24723.0	1	1978.0	1.0	NaN	NaN
2	372.0	2017-01-01 00:38:19	2017-01-01 00:44:31	3183	Exchange Place	40.716247	-74.033459	3211	Newark Ave	40.721525	-74.046305	24620.0	1	1989.0	1.0	NaN	NaN
3	1513.0	2017-01-01 00:38:37	2017-01-01 01:03:50	3194	McGinley Square	40.725340	-74.067622	3271	Danforth Light Rail	40.692640	-74.088012	24668.0	1	1961.0	1.0	NaN	NaN
4	639.0	2017-01-01 01:47:52	2017-01-01 01:58:31	3183	Exchange Place	40.716247	-74.033459	3203	Hamilton Park	40.727596	-74.044247	26167.0	1	1993.0	1.0	NaN	NaN
5	258.0	2017-01-01 01:56:29	2017-01-01 02:00:48	3186	Grove St PATH	40.719586	-74.043117	3270	Jersey & 6th St	40.725289	-74.045572	24604.0	1	1970.0	1.0	NaN	NaN
6	663.0	2017-01-01 02:12:34	2017-01-01 02:23:38	3270	Jersey & 6th St	40.725289	-74.045572	3206	Hilltop	40.731169	-74.057574	24641.0	1	1978.0	1.0	NaN	NaN
7	567.0	2017-01-01 02:15:52	2017-01-01 02:25:20	3192	Liberty Light Rail	40.711242	-74.055701	3213	Van Vorst Park	40.718489	-74.047727	24513.0	1	1970.0	1.0	NaN	NaN
8	551.0	2017-01-01 02:16:03	2017-01-01 02:25:15	3192	Liberty Light Rail	40.711242	-74.055701	3213	Van Vorst Park	40.718489	-74.047727	24463.0	1	1967.0	2.0	NaN	NaN
9	573.0	2017-01-01 02:22:17	2017-01-01 02:31:50	3212	Christ Hospital	40.734786	-74.050444	3225	Baldwin at Montgomery	40.723659	-74.064194	24486.0	1	1984.0	1.0	NaN	NaN

	trip_duration	start_time	stop_time	start_station_id	start_station_name	start_station_latitude	start_station_longitude	end_station_id	end_station_name	end_station_latitude	end_station_longitude	bike_id	user_type	birth_year	gender	ride_id	rideable_type
4207967	76.0	NaT	NaT	3185	City Hall	40.717732	-74.043845	3185	City Hall	40.717732	-74.043845	44737.0	1	1976.0	1.0	NaN	NaN
4207968	305.0	NaT	NaT	3186	Grove St PATH	40.719586	-74.043117	3203	Hamilton Park	40.727596	-74.044247	42213.0	1	1996.0	1.0	NaN	NaN
4207969	99.0	NaT	NaT	3185	City Hall	40.717732	-74.043845	3185	City Hall	40.717732	-74.043845	44347.0	1	1976.0	1.0	NaN	NaN
4207970	492.0	NaT	NaT	3195	Sip Ave	40.730897	-74.063913	3225	Baldwin at Montgomery	40.723659	-74.064194	46598.0	0	1998.0	1.0	NaN	NaN
4207971	715.0	NaT	NaT	3185	City Hall	40.717732	-74.043845	3269	Brunswick & 6th	40.726012	-74.050389	44737.0	1	1976.0	1.0	NaN	NaN
4207972	270.0	NaT	NaT	3207	Oakland Ave	40.737604	-74.052478	3640	Journal Square	40.733670	-74.062500	44744.0	1	1963.0	2.0	NaN	NaN
4207973	400.0	NaT	NaT	3209	Brunswick St	40.724176	-74.050656	3209	Brunswick St	40.724176	-74.050656	45345.0	1	1984.0	1.0	NaN	NaN
4207974	206.0	NaT	NaT	3195	Sip Ave	40.730897	-74.063913	3194	McGinley Square	40.725340	-74.067622	47019.0	1	1993.0	1.0	NaN	NaN
4207975	216.0	NaT	NaT	3195	Sip Ave	40.730897	-74.063913	3225	Baldwin at Montgomery	40.723659	-74.064194	42191.0	1	1966.0	1.0	NaN	NaN
4207976	418.0	NaT	NaT	3267	Morris Canal	40.712419	-74.038526	3186	Grove St PATH	40.719586	-74.043117	47255.0	1	1991.0	1.0	NaN	NaN

Most frequently occurring

	trip_duration	start_time	stop_time	start_station_name	start_station_latitude	start_station_longitude	end_station_name	end_station_latitude	end_station_longitude	bike_id	user_type	birth_year	gender	ride_id	rideable_type	# duplicates
834	166.0	NaT	NaT	Monmouth and 6th	40.725685	-74.048790	Manila & 1st	40.721651	-74.042884	29555.0	1	1993.0	1.0	NaN	NaN	3
2229	247.0	NaT	NaT	Dey St	40.737711	-74.066921	5 Corners Library	40.734961	-74.059503	45350.0	1	1978.0	1.0	NaN	NaN	3
7306	601.0	NaT	NaT	Newport Pkwy	40.728745	-74.032108	Essex Light Rail	40.712774	-74.036486	42178.0	1	1980.0	1.0	NaN	NaN	3
0	61.0	NaT	NaT	Brunswick & 6th	40.726012	-74.050389	Brunswick St	40.724176	-74.050656	33887.0	1	1987.0	1.0	NaN	NaN	2
1	61.0	NaT	NaT	Sip Ave	40.730897	-74.063913	Sip Ave	40.730897	-74.063913	42535.0	1	1977.0	2.0	NaN	NaN	2
2	62.0	NaT	NaT	City Hall	40.717732	-74.043845	City Hall	40.717732	-74.043845	33859.0	1	1972.0	1.0	NaN	NaN	2
3	62.0	NaT	NaT	Jersey & 6th St	40.725289	-74.045572	Jersey & 3rd	40.723332	-74.045953	33859.0	1	1977.0	1.0	NaN	NaN	2
4	62.0	NaT	NaT	Warren St	40.721124	-74.038051	Warren St	40.721124	-74.038051	42195.0	1	1970.0	2.0	NaN	NaN	2
5	63.0	NaT	NaT	Grove St PATH	40.719586	-74.043117	City Hall	40.717732	-74.043845	29588.0	1	1987.0	1.0	NaN	NaN	2
6	63.0	NaT	NaT	Newport Pkwy	40.728745	-74.032108	Newport Pkwy	40.728745	-74.032108	42460.0	1	1986.0	1.0	NaN	NaN	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length